﻿-- Creating table 'PhysicianAbsents'
-- Creating table 'PhysicianAbsents'
-- Creating table 'PhysicianAbsents'
-- Creating table 'PhysicianAbsents'
-- Creating table 'PhysicianAbsents'
CREATE TABLE [dbo].[PhysicianAbsents] (
    [PhysicianAbsentID] int IDENTITY(1,1) NOT NULL,
    [Physician] nvarchar(5)  NOT NULL,
    [Reason] nvarchar(50)  NOT NULL,
    [ServiceID] int  NULL,
    [BeginDate] datetime  NOT NULL,
    [EndDate] datetime  NULL,
    [IsDeleted] bit  NOT NULL
);














